Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 570394 |
| Missing cells | 2992834 |
| Missing cells (%) | 16.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 134.9 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| Categorical | 5 |
| Text | 6 |
CANCELLED is highly imbalanced (96.2%) | Imbalance |
DIVERTED is highly imbalanced (97.9%) | Imbalance |
CANCELLATION_CODE has 568084 (99.6%) missing values | Missing |
CARRIER_DELAY has 481241 (84.4%) missing values | Missing |
WEATHER_DELAY has 481241 (84.4%) missing values | Missing |
NAS_DELAY has 481241 (84.4%) missing values | Missing |
SECURITY_DELAY has 481241 (84.4%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 481241 (84.4%) missing values | Missing |
SECURITY_DELAY is highly skewed (γ1 = 34.0490753) | Skewed |
DEP_DELAY has 27576 (4.8%) zeros | Zeros |
ARR_DELAY has 10088 (1.8%) zeros | Zeros |
CARRIER_DELAY has 39145 (6.9%) zeros | Zeros |
WEATHER_DELAY has 85878 (15.1%) zeros | Zeros |
NAS_DELAY has 44910 (7.9%) zeros | Zeros |
SECURITY_DELAY has 88394 (15.5%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 45982 (8.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 06:11:48.350749 |
|---|---|
| Analysis finished | 2024-03-30 06:14:44.268681 |
| Duration | 2 minutes and 55.92 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1730979 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9879171 |
|---|---|
| Coefficient of variation (CV) | 0.47636485 |
| Kurtosis | -1.2135648 |
| Mean | 4.1730979 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.13505156 |
| Sum | 2380310 |
| Variance | 3.9518145 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 5 | 97191 | |
| 7 | 89536 | |
| 6 | 85997 | |
| 4 | 77853 | |
| 3 | 73891 | |
| 1 | 73316 | |
| 2 | 72610 |
| Value | Count | Frequency (%) |
| 1 | 73316 | |
| 2 | 72610 | |
| 3 | 73891 | |
| 4 | 77853 | |
| 5 | 97191 | |
| 6 | 85997 | |
| 7 | 89536 |
| Value | Count | Frequency (%) |
| 7 | 89536 | |
| 6 | 85997 | |
| 5 | 97191 | |
| 4 | 77853 | |
| 3 | 73891 | |
| 2 | 72610 | |
| 1 | 73316 |
FL_DATE
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| 12/22/2023 12:00:00 AM | 19840 |
|---|---|
| 12/21/2023 12:00:00 AM | 19752 |
| 12/15/2023 12:00:00 AM | 19558 |
| 12/14/2023 12:00:00 AM | 19484 |
| 12/7/2023 12:00:00 AM | 19432 |
| Other values (26) |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 21.713314 |
| Min length | 21 |
Characters and Unicode
| Total characters | 12385144 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 12/4/2023 12:00:00 AM |
|---|---|
| 2nd row | 12/4/2023 12:00:00 AM |
| 3rd row | 12/4/2023 12:00:00 AM |
| 4th row | 12/4/2023 12:00:00 AM |
| 5th row | 12/4/2023 12:00:00 AM |
Common Values
| Value | Count | Frequency (%) |
| 12/22/2023 12:00:00 AM | 19840 | 3.5% |
| 12/21/2023 12:00:00 AM | 19752 | 3.5% |
| 12/15/2023 12:00:00 AM | 19558 | 3.4% |
| 12/14/2023 12:00:00 AM | 19484 | 3.4% |
| 12/7/2023 12:00:00 AM | 19432 | 3.4% |
| 12/8/2023 12:00:00 AM | 19415 | 3.4% |
| 12/29/2023 12:00:00 AM | 19283 | 3.4% |
| 12/26/2023 12:00:00 AM | 19207 | 3.4% |
| 12/11/2023 12:00:00 AM | 19206 | 3.4% |
| 12/10/2023 12:00:00 AM | 19195 | 3.4% |
| Other values (21) | 376022 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 12:00:00 | 570394 | |
| am | 570394 | |
| 12/22/2023 | 19840 | 1.2% |
| 12/21/2023 | 19752 | 1.2% |
| 12/15/2023 | 19558 | 1.1% |
| 12/14/2023 | 19484 | 1.1% |
| 12/7/2023 | 19432 | 1.1% |
| 12/8/2023 | 19415 | 1.1% |
| 12/29/2023 | 19283 | 1.1% |
| 12/26/2023 | 19207 | 1.1% |
| Other values (23) | 414423 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2908740 | |
| 2 | 2521869 | |
| 1 | 1400691 | |
| / | 1140788 | 9.2% |
| 1140788 | 9.2% | |
| : | 1140788 | 9.2% |
| 3 | 661379 | 5.3% |
| A | 570394 | 4.6% |
| M | 570394 | 4.6% |
| 8 | 57276 | 0.5% |
| Other values (5) | 272037 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12385144 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2908740 | |
| 2 | 2521869 | |
| 1 | 1400691 | |
| / | 1140788 | 9.2% |
| 1140788 | 9.2% | |
| : | 1140788 | 9.2% |
| 3 | 661379 | 5.3% |
| A | 570394 | 4.6% |
| M | 570394 | 4.6% |
| 8 | 57276 | 0.5% |
| Other values (5) | 272037 | 2.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12385144 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2908740 | |
| 2 | 2521869 | |
| 1 | 1400691 | |
| / | 1140788 | 9.2% |
| 1140788 | 9.2% | |
| : | 1140788 | 9.2% |
| 3 | 661379 | 5.3% |
| A | 570394 | 4.6% |
| M | 570394 | 4.6% |
| 8 | 57276 | 0.5% |
| Other values (5) | 272037 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12385144 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2908740 | |
| 2 | 2521869 | |
| 1 | 1400691 | |
| / | 1140788 | 9.2% |
| 1140788 | 9.2% | |
| : | 1140788 | 9.2% |
| 3 | 661379 | 5.3% |
| A | 570394 | 4.6% |
| M | 570394 | 4.6% |
| 8 | 57276 | 0.5% |
| Other values (5) | 272037 | 2.2% |
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1140788 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 127773 | |
| DL | 81022 | |
| AA | 75408 | |
| UA | 59844 | |
| OO | 55996 | |
| NK | 22583 | 4.0% |
| YX | 21641 | 3.8% |
| B6 | 21398 | 3.8% |
| MQ | 20420 | 3.6% |
| AS | 19400 | 3.4% |
| Other values (5) | 64909 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 127773 | |
| dl | 81022 | |
| aa | 75408 | |
| ua | 59844 | |
| oo | 55996 | |
| nk | 22583 | 4.0% |
| yx | 21641 | 3.8% |
| b6 | 21398 | 3.8% |
| mq | 20420 | 3.6% |
| as | 19400 | 3.4% |
| Other values (5) | 64909 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 236762 | |
| N | 150356 | |
| O | 128133 | |
| W | 127773 | |
| D | 81022 | 7.1% |
| L | 81022 | 7.1% |
| U | 59844 | 5.2% |
| 9 | 32586 | 2.9% |
| H | 22843 | 2.0% |
| K | 22583 | 2.0% |
| Other values (11) | 197864 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1140788 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 236762 | |
| N | 150356 | |
| O | 128133 | |
| W | 127773 | |
| D | 81022 | 7.1% |
| L | 81022 | 7.1% |
| U | 59844 | 5.2% |
| 9 | 32586 | 2.9% |
| H | 22843 | 2.0% |
| K | 22583 | 2.0% |
| Other values (11) | 197864 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1140788 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 236762 | |
| N | 150356 | |
| O | 128133 | |
| W | 127773 | |
| D | 81022 | 7.1% |
| L | 81022 | 7.1% |
| U | 59844 | 5.2% |
| 9 | 32586 | 2.9% |
| H | 22843 | 2.0% |
| K | 22583 | 2.0% |
| Other values (11) | 197864 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1140788 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 236762 | |
| N | 150356 | |
| O | 128133 | |
| W | 127773 | |
| D | 81022 | 7.1% |
| L | 81022 | 7.1% |
| U | 59844 | 5.2% |
| 9 | 32586 | 2.9% |
| H | 22843 | 2.0% |
| K | 22583 | 2.0% |
| Other values (11) | 197864 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5873 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2289.1566 |
| Minimum | 1 |
|---|---|
| Maximum | 8819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 282 |
| Q1 | 1046 |
| median | 2043 |
| Q3 | 3343 |
| 95-th percentile | 5364 |
| Maximum | 8819 |
| Range | 8818 |
| Interquartile range (IQR) | 2297 |
Descriptive statistics
| Standard deviation | 1558.49 |
|---|---|
| Coefficient of variation (CV) | 0.68081406 |
| Kurtosis | -0.55132119 |
| Mean | 2289.1566 |
| Median Absolute Deviation (MAD) | 1099 |
| Skewness | 0.61889059 |
| Sum | 1.3057212 × 109 |
| Variance | 2428891.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 540 | 319 | 0.1% |
| 323 | 306 | 0.1% |
| 706 | 303 | 0.1% |
| 533 | 301 | 0.1% |
| 1201 | 301 | 0.1% |
| 1744 | 300 | 0.1% |
| 421 | 297 | 0.1% |
| 1173 | 296 | 0.1% |
| 649 | 294 | 0.1% |
| 1245 | 293 | 0.1% |
| Other values (5863) | 567384 |
| Value | Count | Frequency (%) |
| 1 | 164 | |
| 2 | 131 | |
| 3 | 119 | |
| 4 | 164 | |
| 5 | 136 | |
| 6 | 95 | |
| 7 | 116 | |
| 8 | 165 | |
| 9 | 145 | |
| 10 | 101 |
| Value | Count | Frequency (%) |
| 8819 | 5 | |
| 8810 | 1 | < 0.1% |
| 8806 | 1 | < 0.1% |
| 8805 | 1 | < 0.1% |
| 8804 | 2 | < 0.1% |
| 8803 | 1 | < 0.1% |
| 8802 | 2 | < 0.1% |
| 8801 | 1 | < 0.1% |
| 8800 | 8 | |
| 8799 | 1 | < 0.1% |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12659.526 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14057 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2765 |
Descriptive statistics
| Standard deviation | 1530.9803 |
|---|---|
| Coefficient of variation (CV) | 0.12093504 |
| Kurtosis | -1.2999836 |
| Mean | 12659.526 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.099593906 |
| Sum | 7.2209178 × 109 |
| Variance | 2343900.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28027 | 4.9% |
| 11292 | 25054 | 4.4% |
| 11298 | 23714 | 4.2% |
| 13930 | 20664 | 3.6% |
| 11057 | 16220 | 2.8% |
| 14107 | 15996 | 2.8% |
| 12892 | 15948 | 2.8% |
| 12889 | 15872 | 2.8% |
| 13204 | 15112 | 2.6% |
| 14747 | 12736 | 2.2% |
| Other values (324) | 381051 |
| Value | Count | Frequency (%) |
| 10135 | 376 | 0.1% |
| 10136 | 149 | < 0.1% |
| 10140 | 2034 | |
| 10141 | 60 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10155 | 92 | < 0.1% |
| 10157 | 155 | < 0.1% |
| 10158 | 307 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 50 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 152 | < 0.1% |
| 16218 | 137 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 997 | |
| 15841 | 60 | < 0.1% |
| 15624 | 599 | |
| 15607 | 62 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
| 15412 | 1147 |
ORIGIN
Text
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1711182 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | LGA |
| 3rd row | TYS |
| 4th row | LGA |
| 5th row | LGA |
| Value | Count | Frequency (%) |
| atl | 28027 | 4.9% |
| den | 25054 | 4.4% |
| dfw | 23714 | 4.2% |
| ord | 20664 | 3.6% |
| clt | 16220 | 2.8% |
| phx | 15996 | 2.8% |
| lax | 15948 | 2.8% |
| las | 15872 | 2.8% |
| mco | 15112 | 2.6% |
| sea | 12736 | 2.2% |
| Other values (324) | 381051 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 194744 | 11.4% |
| L | 158553 | 9.3% |
| S | 146264 | 8.5% |
| D | 132285 | 7.7% |
| T | 91003 | 5.3% |
| O | 86878 | 5.1% |
| C | 85813 | 5.0% |
| M | 78312 | 4.6% |
| F | 70441 | 4.1% |
| N | 66826 | 3.9% |
| Other values (16) | 600063 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 194744 | 11.4% |
| L | 158553 | 9.3% |
| S | 146264 | 8.5% |
| D | 132285 | 7.7% |
| T | 91003 | 5.3% |
| O | 86878 | 5.1% |
| C | 85813 | 5.0% |
| M | 78312 | 4.6% |
| F | 70441 | 4.1% |
| N | 66826 | 3.9% |
| Other values (16) | 600063 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 194744 | 11.4% |
| L | 158553 | 9.3% |
| S | 146264 | 8.5% |
| D | 132285 | 7.7% |
| T | 91003 | 5.3% |
| O | 86878 | 5.1% |
| C | 85813 | 5.0% |
| M | 78312 | 4.6% |
| F | 70441 | 4.1% |
| N | 66826 | 3.9% |
| Other values (16) | 600063 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 194744 | 11.4% |
| L | 158553 | 9.3% |
| S | 146264 | 8.5% |
| D | 132285 | 7.7% |
| T | 91003 | 5.3% |
| O | 86878 | 5.1% |
| C | 85813 | 5.0% |
| M | 78312 | 4.6% |
| F | 70441 | 4.1% |
| N | 66826 | 3.9% |
| Other values (16) | 600063 |
ORIGIN_CITY_NAME
Text
| Distinct | 328 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.05763 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7447994 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | New York, NY |
| 3rd row | Knoxville, TN |
| 4th row | New York, NY |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 61792 | 4.6% |
| tx | 60822 | 4.6% |
| fl | 56986 | 4.3% |
| san | 30263 | 2.3% |
| ga | 29881 | 2.2% |
| ny | 29364 | 2.2% |
| il | 28539 | 2.1% |
| co | 28155 | 2.1% |
| atlanta | 28027 | 2.1% |
| chicago | 27500 | 2.1% |
| Other values (399) | 950779 |
Most occurring characters
| Value | Count | Frequency (%) |
| 761714 | 10.2% | |
| a | 572368 | 7.7% |
| , | 570394 | 7.7% |
| o | 407531 | 5.5% |
| e | 394504 | 5.3% |
| n | 365633 | 4.9% |
| t | 352686 | 4.7% |
| l | 329837 | 4.4% |
| i | 281858 | 3.8% |
| r | 270350 | 3.6% |
| Other values (46) | 3141119 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7447994 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 761714 | 10.2% | |
| a | 572368 | 7.7% |
| , | 570394 | 7.7% |
| o | 407531 | 5.5% |
| e | 394504 | 5.3% |
| n | 365633 | 4.9% |
| t | 352686 | 4.7% |
| l | 329837 | 4.4% |
| i | 281858 | 3.8% |
| r | 270350 | 3.6% |
| Other values (46) | 3141119 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7447994 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 761714 | 10.2% | |
| a | 572368 | 7.7% |
| , | 570394 | 7.7% |
| o | 407531 | 5.5% |
| e | 394504 | 5.3% |
| n | 365633 | 4.9% |
| t | 352686 | 4.7% |
| l | 329837 | 4.4% |
| i | 281858 | 3.8% |
| r | 270350 | 3.6% |
| Other values (46) | 3141119 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7447994 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 761714 | 10.2% | |
| a | 572368 | 7.7% |
| , | 570394 | 7.7% |
| o | 407531 | 5.5% |
| e | 394504 | 5.3% |
| n | 365633 | 4.9% |
| t | 352686 | 4.7% |
| l | 329837 | 4.4% |
| i | 281858 | 3.8% |
| r | 270350 | 3.6% |
| Other values (46) | 3141119 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1137091 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4628011 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | New York |
| 3rd row | Tennessee |
| 4th row | New York |
| 5th row | New York |
| Value | Count | Frequency (%) |
| california | 61792 | 9.5% |
| texas | 60822 | 9.3% |
| florida | 56986 | 8.8% |
| new | 43138 | 6.6% |
| georgia | 29881 | 4.6% |
| york | 29364 | 4.5% |
| illinois | 28539 | 4.4% |
| colorado | 28155 | 4.3% |
| carolina | 28132 | 4.3% |
| north | 25050 | 3.8% |
| Other values (51) | 258836 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 626453 | |
| i | 521790 | 11.3% |
| o | 452661 | 9.8% |
| r | 342481 | 7.4% |
| n | 336183 | 7.3% |
| e | 278712 | 6.0% |
| l | 262140 | 5.7% |
| s | 256941 | 5.6% |
| d | 121057 | 2.6% |
| C | 119750 | 2.6% |
| Other values (37) | 1309843 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4628011 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 626453 | |
| i | 521790 | 11.3% |
| o | 452661 | 9.8% |
| r | 342481 | 7.4% |
| n | 336183 | 7.3% |
| e | 278712 | 6.0% |
| l | 262140 | 5.7% |
| s | 256941 | 5.6% |
| d | 121057 | 2.6% |
| C | 119750 | 2.6% |
| Other values (37) | 1309843 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4628011 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 626453 | |
| i | 521790 | 11.3% |
| o | 452661 | 9.8% |
| r | 342481 | 7.4% |
| n | 336183 | 7.3% |
| e | 278712 | 6.0% |
| l | 262140 | 5.7% |
| s | 256941 | 5.6% |
| d | 121057 | 2.6% |
| C | 119750 | 2.6% |
| Other values (37) | 1309843 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4628011 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 626453 | |
| i | 521790 | 11.3% |
| o | 452661 | 9.8% |
| r | 342481 | 7.4% |
| n | 336183 | 7.3% |
| e | 278712 | 6.0% |
| l | 262140 | 5.7% |
| s | 256941 | 5.6% |
| d | 121057 | 2.6% |
| C | 119750 | 2.6% |
| Other values (37) | 1309843 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.892013 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 51 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.668044 |
|---|---|
| Coefficient of variation (CV) | 0.4858274 |
| Kurtosis | -1.3177813 |
| Mean | 54.892013 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.043781722 |
| Sum | 31310075 |
| Variance | 711.18458 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 61792 | 10.8% |
| 74 | 60822 | 10.7% |
| 33 | 56986 | 10.0% |
| 34 | 29881 | 5.2% |
| 22 | 29364 | 5.1% |
| 41 | 28539 | 5.0% |
| 82 | 28155 | 4.9% |
| 36 | 23592 | 4.1% |
| 38 | 18587 | 3.3% |
| 81 | 18418 | 3.2% |
| Other values (42) | 214258 |
| Value | Count | Frequency (%) |
| 1 | 2476 | 0.4% |
| 2 | 11108 | |
| 3 | 3401 | 0.6% |
| 4 | 664 | 0.1% |
| 5 | 102 | < 0.1% |
| 11 | 1671 | 0.3% |
| 12 | 893 | 0.2% |
| 13 | 10756 | |
| 14 | 489 | 0.1% |
| 15 | 1081 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 14966 | 2.6% |
| 92 | 6337 | 1.1% |
| 91 | 61792 | |
| 88 | 816 | 0.1% |
| 87 | 9827 | 1.7% |
| 86 | 2220 | 0.4% |
| 85 | 17543 | 3.1% |
| 84 | 2009 | 0.4% |
| 83 | 2363 | 0.4% |
| 82 | 28155 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12659.658 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14057 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2765 |
Descriptive statistics
| Standard deviation | 1531.0627 |
|---|---|
| Coefficient of variation (CV) | 0.12094029 |
| Kurtosis | -1.3000314 |
| Mean | 12659.658 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.099440234 |
| Sum | 7.2209931 × 109 |
| Variance | 2344153 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 28052 | 4.9% |
| 11292 | 25057 | 4.4% |
| 11298 | 23680 | 4.2% |
| 13930 | 20661 | 3.6% |
| 11057 | 16213 | 2.8% |
| 14107 | 16002 | 2.8% |
| 12892 | 15955 | 2.8% |
| 12889 | 15872 | 2.8% |
| 13204 | 15125 | 2.7% |
| 14747 | 12726 | 2.2% |
| Other values (324) | 381051 |
| Value | Count | Frequency (%) |
| 10135 | 376 | 0.1% |
| 10136 | 149 | < 0.1% |
| 10140 | 2033 | |
| 10141 | 60 | < 0.1% |
| 10146 | 62 | < 0.1% |
| 10155 | 92 | < 0.1% |
| 10157 | 155 | < 0.1% |
| 10158 | 306 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 49 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 152 | < 0.1% |
| 16218 | 137 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 999 | |
| 15841 | 60 | < 0.1% |
| 15624 | 599 | |
| 15607 | 62 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
| 15412 | 1147 |
DEST
Text
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1711182 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STL |
|---|---|
| 2nd row | SYR |
| 3rd row | LGA |
| 4th row | TYS |
| 5th row | ORF |
| Value | Count | Frequency (%) |
| atl | 28052 | 4.9% |
| den | 25057 | 4.4% |
| dfw | 23680 | 4.2% |
| ord | 20661 | 3.6% |
| clt | 16213 | 2.8% |
| phx | 16002 | 2.8% |
| lax | 15955 | 2.8% |
| las | 15872 | 2.8% |
| mco | 15125 | 2.7% |
| sea | 12726 | 2.2% |
| Other values (324) | 381051 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 194750 | 11.4% |
| L | 158614 | 9.3% |
| S | 146305 | 8.5% |
| D | 132236 | 7.7% |
| T | 91011 | 5.3% |
| O | 86895 | 5.1% |
| C | 85813 | 5.0% |
| M | 78325 | 4.6% |
| F | 70439 | 4.1% |
| N | 66835 | 3.9% |
| Other values (16) | 599959 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 194750 | 11.4% |
| L | 158614 | 9.3% |
| S | 146305 | 8.5% |
| D | 132236 | 7.7% |
| T | 91011 | 5.3% |
| O | 86895 | 5.1% |
| C | 85813 | 5.0% |
| M | 78325 | 4.6% |
| F | 70439 | 4.1% |
| N | 66835 | 3.9% |
| Other values (16) | 599959 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 194750 | 11.4% |
| L | 158614 | 9.3% |
| S | 146305 | 8.5% |
| D | 132236 | 7.7% |
| T | 91011 | 5.3% |
| O | 86895 | 5.1% |
| C | 85813 | 5.0% |
| M | 78325 | 4.6% |
| F | 70439 | 4.1% |
| N | 66835 | 3.9% |
| Other values (16) | 599959 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 194750 | 11.4% |
| L | 158614 | 9.3% |
| S | 146305 | 8.5% |
| D | 132236 | 7.7% |
| T | 91011 | 5.3% |
| O | 86895 | 5.1% |
| C | 85813 | 5.0% |
| M | 78325 | 4.6% |
| F | 70439 | 4.1% |
| N | 66835 | 3.9% |
| Other values (16) | 599959 |
DEST_CITY_NAME
Text
| Distinct | 328 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.057765 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7448071 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | St. Louis, MO |
|---|---|
| 2nd row | Syracuse, NY |
| 3rd row | New York, NY |
| 4th row | Knoxville, TN |
| 5th row | Norfolk, VA |
| Value | Count | Frequency (%) |
| ca | 61806 | 4.6% |
| tx | 60779 | 4.6% |
| fl | 57050 | 4.3% |
| san | 30283 | 2.3% |
| ga | 29904 | 2.2% |
| ny | 29343 | 2.2% |
| il | 28538 | 2.1% |
| co | 28163 | 2.1% |
| atlanta | 28052 | 2.1% |
| chicago | 27498 | 2.1% |
| Other values (399) | 950741 |
Most occurring characters
| Value | Count | Frequency (%) |
| 761763 | 10.2% | |
| a | 572465 | 7.7% |
| , | 570394 | 7.7% |
| o | 407456 | 5.5% |
| e | 394552 | 5.3% |
| n | 365701 | 4.9% |
| t | 352660 | 4.7% |
| l | 329834 | 4.4% |
| i | 281897 | 3.8% |
| r | 270296 | 3.6% |
| Other values (46) | 3141053 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7448071 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 761763 | 10.2% | |
| a | 572465 | 7.7% |
| , | 570394 | 7.7% |
| o | 407456 | 5.5% |
| e | 394552 | 5.3% |
| n | 365701 | 4.9% |
| t | 352660 | 4.7% |
| l | 329834 | 4.4% |
| i | 281897 | 3.8% |
| r | 270296 | 3.6% |
| Other values (46) | 3141053 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7448071 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 761763 | 10.2% | |
| a | 572465 | 7.7% |
| , | 570394 | 7.7% |
| o | 407456 | 5.5% |
| e | 394552 | 5.3% |
| n | 365701 | 4.9% |
| t | 352660 | 4.7% |
| l | 329834 | 4.4% |
| i | 281897 | 3.8% |
| r | 270296 | 3.6% |
| Other values (46) | 3141053 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7448071 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 761763 | 10.2% | |
| a | 572465 | 7.7% |
| , | 570394 | 7.7% |
| o | 407456 | 5.5% |
| e | 394552 | 5.3% |
| n | 365701 | 4.9% |
| t | 352660 | 4.7% |
| l | 329834 | 4.4% |
| i | 281897 | 3.8% |
| r | 270296 | 3.6% |
| Other values (46) | 3141053 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.113483 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4627882 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Missouri |
|---|---|
| 2nd row | New York |
| 3rd row | New York |
| 4th row | Tennessee |
| 5th row | Virginia |
| Value | Count | Frequency (%) |
| california | 61806 | 9.5% |
| texas | 60779 | 9.3% |
| florida | 57050 | 8.8% |
| new | 43100 | 6.6% |
| georgia | 29904 | 4.6% |
| york | 29343 | 4.5% |
| illinois | 28538 | 4.4% |
| colorado | 28163 | 4.3% |
| carolina | 28114 | 4.3% |
| north | 25038 | 3.8% |
| Other values (51) | 258816 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 626472 | |
| i | 521850 | 11.3% |
| o | 452752 | 9.8% |
| r | 342517 | 7.4% |
| n | 336135 | 7.3% |
| e | 278609 | 6.0% |
| l | 262193 | 5.7% |
| s | 256863 | 5.6% |
| d | 121135 | 2.6% |
| C | 119754 | 2.6% |
| Other values (37) | 1309602 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4627882 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 626472 | |
| i | 521850 | 11.3% |
| o | 452752 | 9.8% |
| r | 342517 | 7.4% |
| n | 336135 | 7.3% |
| e | 278609 | 6.0% |
| l | 262193 | 5.7% |
| s | 256863 | 5.6% |
| d | 121135 | 2.6% |
| C | 119754 | 2.6% |
| Other values (37) | 1309602 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4627882 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 626472 | |
| i | 521850 | 11.3% |
| o | 452752 | 9.8% |
| r | 342517 | 7.4% |
| n | 336135 | 7.3% |
| e | 278609 | 6.0% |
| l | 262193 | 5.7% |
| s | 256863 | 5.6% |
| d | 121135 | 2.6% |
| C | 119754 | 2.6% |
| Other values (37) | 1309602 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4627882 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 626472 | |
| i | 521850 | 11.3% |
| o | 452752 | 9.8% |
| r | 342517 | 7.4% |
| n | 336135 | 7.3% |
| e | 278609 | 6.0% |
| l | 262193 | 5.7% |
| s | 256863 | 5.6% |
| d | 121135 | 2.6% |
| C | 119754 | 2.6% |
| Other values (37) | 1309602 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.891053 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 51 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.668717 |
|---|---|
| Coefficient of variation (CV) | 0.48584817 |
| Kurtosis | -1.3177557 |
| Mean | 54.891053 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.043748191 |
| Sum | 31309527 |
| Variance | 711.22048 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 61806 | 10.8% |
| 74 | 60779 | 10.7% |
| 33 | 57050 | 10.0% |
| 34 | 29904 | 5.2% |
| 22 | 29343 | 5.1% |
| 41 | 28538 | 5.0% |
| 82 | 28163 | 4.9% |
| 36 | 23581 | 4.1% |
| 38 | 18572 | 3.3% |
| 81 | 18426 | 3.2% |
| Other values (42) | 214232 |
| Value | Count | Frequency (%) |
| 1 | 2478 | 0.4% |
| 2 | 11108 | |
| 3 | 3412 | 0.6% |
| 4 | 664 | 0.1% |
| 5 | 102 | < 0.1% |
| 11 | 1671 | 0.3% |
| 12 | 889 | 0.2% |
| 13 | 10757 | |
| 14 | 489 | 0.1% |
| 15 | 1084 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 14953 | 2.6% |
| 92 | 6327 | 1.1% |
| 91 | 61806 | |
| 88 | 817 | 0.1% |
| 87 | 9845 | 1.7% |
| 86 | 2219 | 0.4% |
| 85 | 17543 | 3.1% |
| 84 | 2010 | 0.4% |
| 83 | 2364 | 0.4% |
| 82 | 28163 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1241 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1328.2608 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 905 |
| median | 1322 |
| Q3 | 1740 |
| 95-th percentile | 2128 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 835 |
Descriptive statistics
| Standard deviation | 496.32683 |
|---|---|
| Coefficient of variation (CV) | 0.37366671 |
| Kurtosis | -1.0701988 |
| Mean | 1328.2608 |
| Median Absolute Deviation (MAD) | 417 |
| Skewness | 0.074999195 |
| Sum | 7.5763198 × 108 |
| Variance | 246340.33 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 12107 | 2.1% |
| 700 | 9261 | 1.6% |
| 800 | 5837 | 1.0% |
| 900 | 3915 | 0.7% |
| 1000 | 3738 | 0.7% |
| 630 | 3355 | 0.6% |
| 730 | 3240 | 0.6% |
| 615 | 2869 | 0.5% |
| 830 | 2835 | 0.5% |
| 1100 | 2807 | 0.5% |
| Other values (1231) | 520430 |
| Value | Count | Frequency (%) |
| 1 | 8 | < 0.1% |
| 3 | 2 | < 0.1% |
| 4 | 11 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 7 | 7 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 42 | |
| 10 | 1 | < 0.1% |
| 11 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 1191 | |
| 2358 | 63 | < 0.1% |
| 2357 | 27 | < 0.1% |
| 2356 | 29 | < 0.1% |
| 2355 | 247 | < 0.1% |
| 2354 | 54 | < 0.1% |
| 2353 | 27 | < 0.1% |
| 2352 | 18 | < 0.1% |
| 2351 | 46 | < 0.1% |
| 2350 | 100 | < 0.1% |
DEP_TIME
Real number (ℝ)
| Distinct | 1419 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2186 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1330.1195 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 557 |
| Q1 | 908 |
| median | 1326 |
| Q3 | 1744 |
| 95-th percentile | 2135 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 836 |
Descriptive statistics
| Standard deviation | 506.68853 |
|---|---|
| Coefficient of variation (CV) | 0.38093458 |
| Kurtosis | -1.0174795 |
| Mean | 1330.1195 |
| Median Absolute Deviation (MAD) | 418 |
| Skewness | 0.034564466 |
| Sum | 7.5578456 × 108 |
| Variance | 256733.27 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 1555 | 0.3% |
| 557 | 1390 | 0.2% |
| 556 | 1385 | 0.2% |
| 558 | 1336 | 0.2% |
| 559 | 1228 | 0.2% |
| 554 | 1218 | 0.2% |
| 655 | 1204 | 0.2% |
| 600 | 1164 | 0.2% |
| 658 | 1105 | 0.2% |
| 657 | 1101 | 0.2% |
| Other values (1409) | 555522 | |
| (Missing) | 2186 | 0.4% |
| Value | Count | Frequency (%) |
| 1 | 59 | |
| 2 | 57 | |
| 3 | 53 | |
| 4 | 48 | |
| 5 | 53 | |
| 6 | 54 | |
| 7 | 48 | |
| 8 | 44 | |
| 9 | 48 | |
| 10 | 44 |
| Value | Count | Frequency (%) |
| 2400 | 50 | < 0.1% |
| 2359 | 88 | |
| 2358 | 101 | |
| 2357 | 96 | |
| 2356 | 116 | |
| 2355 | 130 | |
| 2354 | 148 | |
| 2353 | 125 | |
| 2352 | 120 | |
| 2351 | 130 |
DEP_DELAY
Real number (ℝ)
ZEROS
| Distinct | 1072 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2199 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.2743143 |
| Minimum | -99 |
|---|---|
| Maximum | 3786 |
| Zeros | 27576 |
| Zeros (%) | 4.8% |
| Negative | 349562 |
| Negative (%) | 61.3% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | -99 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -2 |
| Q3 | 5 |
| 95-th percentile | 58 |
| Maximum | 3786 |
| Range | 3885 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 47.4198 |
|---|---|
| Coefficient of variation (CV) | 5.7309644 |
| Kurtosis | 385.22163 |
| Mean | 8.2743143 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 14.04448 |
| Sum | 4701424 |
| Variance | 2248.6375 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 44837 | 7.9% |
| -4 | 41881 | 7.3% |
| -3 | 40760 | 7.1% |
| -2 | 36779 | 6.4% |
| -6 | 35988 | 6.3% |
| -1 | 32505 | 5.7% |
| -7 | 30820 | 5.4% |
| 0 | 27576 | 4.8% |
| -8 | 25115 | 4.4% |
| -9 | 18445 | 3.2% |
| Other values (1062) | 233489 |
| Value | Count | Frequency (%) |
| -99 | 1 | < 0.1% |
| -59 | 1 | < 0.1% |
| -49 | 1 | < 0.1% |
| -45 | 2 | |
| -42 | 1 | < 0.1% |
| -40 | 2 | |
| -39 | 2 | |
| -38 | 1 | < 0.1% |
| -37 | 4 | |
| -36 | 2 |
| Value | Count | Frequency (%) |
| 3786 | 1 | |
| 2915 | 1 | |
| 2604 | 1 | |
| 2495 | 1 | |
| 2413 | 1 | |
| 2395 | 1 | |
| 2298 | 1 | |
| 2025 | 1 | |
| 1897 | 1 | |
| 1813 | 1 |
TAXI_OUT
Real number (ℝ)
| Distinct | 139 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2242 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.413953 |
| Minimum | 1 |
|---|---|
| Maximum | 155 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 33 |
| Maximum | 155 |
| Range | 154 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 8.5711332 |
|---|---|
| Coefficient of variation (CV) | 0.49219918 |
| Kurtosis | 12.688846 |
| Mean | 17.413953 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 2.5629355 |
| Sum | 9893772 |
| Variance | 73.464324 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 45607 | 8.0% |
| 12 | 45567 | 8.0% |
| 14 | 42706 | 7.5% |
| 11 | 41766 | 7.3% |
| 15 | 39484 | 6.9% |
| 16 | 34945 | 6.1% |
| 10 | 34480 | 6.0% |
| 17 | 30735 | 5.4% |
| 18 | 26466 | 4.6% |
| 9 | 23395 | 4.1% |
| Other values (129) | 203001 |
| Value | Count | Frequency (%) |
| 1 | 33 | < 0.1% |
| 2 | 22 | < 0.1% |
| 3 | 49 | < 0.1% |
| 4 | 170 | < 0.1% |
| 5 | 520 | 0.1% |
| 6 | 2329 | 0.4% |
| 7 | 6198 | 1.1% |
| 8 | 13007 | 2.3% |
| 9 | 23395 | |
| 10 | 34480 |
| Value | Count | Frequency (%) |
| 155 | 1 | < 0.1% |
| 150 | 1 | < 0.1% |
| 147 | 1 | < 0.1% |
| 144 | 1 | < 0.1% |
| 143 | 3 | |
| 140 | 2 | |
| 138 | 1 | < 0.1% |
| 137 | 1 | < 0.1% |
| 136 | 1 | < 0.1% |
| 133 | 1 | < 0.1% |
TAXI_IN
Real number (ℝ)
| Distinct | 140 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2506 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.0097396 |
| Minimum | 1 |
|---|---|
| Maximum | 193 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 18 |
| Maximum | 193 |
| Range | 192 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.0921938 |
|---|---|
| Coefficient of variation (CV) | 0.76059824 |
| Kurtosis | 40.351238 |
| Mean | 8.0097396 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 4.1497981 |
| Sum | 4548635 |
| Variance | 37.114826 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 86145 | |
| 5 | 82438 | |
| 6 | 67465 | |
| 7 | 55318 | |
| 3 | 48547 | |
| 8 | 42369 | |
| 9 | 33254 | 5.8% |
| 10 | 25943 | 4.5% |
| 11 | 20197 | 3.5% |
| 12 | 15750 | 2.8% |
| Other values (130) | 90462 |
| Value | Count | Frequency (%) |
| 1 | 750 | 0.1% |
| 2 | 11287 | 2.0% |
| 3 | 48547 | |
| 4 | 86145 | |
| 5 | 82438 | |
| 6 | 67465 | |
| 7 | 55318 | |
| 8 | 42369 | |
| 9 | 33254 | 5.8% |
| 10 | 25943 | 4.5% |
| Value | Count | Frequency (%) |
| 193 | 1 | |
| 176 | 1 | |
| 175 | 1 | |
| 172 | 2 | |
| 170 | 1 | |
| 169 | 1 | |
| 165 | 2 | |
| 163 | 1 | |
| 162 | 1 | |
| 161 | 1 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1358 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1490.2792 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 720 |
| Q1 | 1102 |
| median | 1518 |
| Q3 | 1928 |
| 95-th percentile | 2259 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 826 |
Descriptive statistics
| Standard deviation | 525.82911 |
|---|---|
| Coefficient of variation (CV) | 0.35283933 |
| Kurtosis | -0.42972861 |
| Mean | 1490.2792 |
| Median Absolute Deviation (MAD) | 413 |
| Skewness | -0.31775724 |
| Sum | 8.5004631 × 108 |
| Variance | 276496.25 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2359 | 2439 | 0.4% |
| 2200 | 2133 | 0.4% |
| 1640 | 1790 | 0.3% |
| 1855 | 1756 | 0.3% |
| 1845 | 1735 | 0.3% |
| 1810 | 1732 | 0.3% |
| 905 | 1653 | 0.3% |
| 1000 | 1653 | 0.3% |
| 1940 | 1618 | 0.3% |
| 1710 | 1589 | 0.3% |
| Other values (1348) | 552296 |
| Value | Count | Frequency (%) |
| 1 | 66 | < 0.1% |
| 2 | 119 | < 0.1% |
| 3 | 191 | < 0.1% |
| 4 | 191 | < 0.1% |
| 5 | 472 | |
| 6 | 167 | < 0.1% |
| 7 | 129 | < 0.1% |
| 8 | 139 | < 0.1% |
| 9 | 142 | < 0.1% |
| 10 | 492 |
| Value | Count | Frequency (%) |
| 2359 | 2439 | |
| 2358 | 637 | 0.1% |
| 2357 | 850 | 0.1% |
| 2356 | 498 | 0.1% |
| 2355 | 1201 | |
| 2354 | 488 | 0.1% |
| 2353 | 432 | 0.1% |
| 2352 | 469 | 0.1% |
| 2351 | 305 | 0.1% |
| 2350 | 689 | 0.1% |
ARR_TIME
Real number (ℝ)
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 2506 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1469.0953 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 652 |
| Q1 | 1049 |
| median | 1508 |
| Q3 | 1921 |
| 95-th percentile | 2253 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 872 |
Descriptive statistics
| Standard deviation | 539.33587 |
|---|---|
| Coefficient of variation (CV) | 0.3671211 |
| Kurtosis | -0.38442734 |
| Mean | 1469.0953 |
| Median Absolute Deviation (MAD) | 423 |
| Skewness | -0.36349995 |
| Sum | 8.3428157 × 108 |
| Variance | 290883.18 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1656 | 654 | 0.1% |
| 1628 | 647 | 0.1% |
| 1703 | 644 | 0.1% |
| 1634 | 637 | 0.1% |
| 1607 | 637 | 0.1% |
| 1145 | 635 | 0.1% |
| 1635 | 633 | 0.1% |
| 2004 | 632 | 0.1% |
| 1142 | 631 | 0.1% |
| 1643 | 629 | 0.1% |
| Other values (1430) | 561509 | |
| (Missing) | 2506 | 0.4% |
| Value | Count | Frequency (%) |
| 1 | 352 | |
| 2 | 329 | |
| 3 | 332 | |
| 4 | 281 | |
| 5 | 293 | |
| 6 | 306 | |
| 7 | 295 | |
| 8 | 304 | |
| 9 | 282 | |
| 10 | 262 |
| Value | Count | Frequency (%) |
| 2400 | 307 | |
| 2359 | 329 | |
| 2358 | 317 | |
| 2357 | 340 | |
| 2356 | 373 | |
| 2355 | 367 | |
| 2354 | 372 | |
| 2353 | 395 | |
| 2352 | 412 | |
| 2351 | 407 |
ARR_DELAY
Real number (ℝ)
ZEROS
| Distinct | 1102 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 3453 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.50933166 |
| Minimum | -98 |
|---|---|
| Maximum | 3795 |
| Zeros | 10088 |
| Zeros (%) | 1.8% |
| Negative | 381564 |
| Negative (%) | 66.9% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | -98 |
|---|---|
| 5-th percentile | -31 |
| Q1 | -17 |
| median | -8 |
| Q3 | 5 |
| 95-th percentile | 54 |
| Maximum | 3795 |
| Range | 3893 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 49.070609 |
|---|---|
| Coefficient of variation (CV) | 96.343136 |
| Kurtosis | 338.93037 |
| Mean | 0.50933166 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 12.688883 |
| Sum | 288761 |
| Variance | 2407.9247 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -13 | 16059 | 2.8% |
| -12 | 15909 | 2.8% |
| -11 | 15818 | 2.8% |
| -10 | 15598 | 2.7% |
| -14 | 15539 | 2.7% |
| -9 | 15417 | 2.7% |
| -8 | 15162 | 2.7% |
| -15 | 14936 | 2.6% |
| -16 | 14459 | 2.5% |
| -7 | 14403 | 2.5% |
| Other values (1092) | 413641 |
| Value | Count | Frequency (%) |
| -98 | 1 | < 0.1% |
| -97 | 1 | < 0.1% |
| -96 | 1 | < 0.1% |
| -91 | 1 | < 0.1% |
| -88 | 1 | < 0.1% |
| -86 | 3 | |
| -85 | 1 | < 0.1% |
| -83 | 1 | < 0.1% |
| -82 | 4 | |
| -81 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3795 | 1 | |
| 2924 | 1 | |
| 2604 | 1 | |
| 2484 | 1 | |
| 2427 | 1 | |
| 2403 | 1 | |
| 2289 | 1 | |
| 2028 | 1 | |
| 1873 | 1 | |
| 1812 | 1 |
CANCELLED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| 0.0 | |
|---|---|
| 1.0 | 2310 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1711182 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 568084 | |
| 1.0 | 2310 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 568084 | |
| 1.0 | 2310 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1138478 | |
| . | 570394 | |
| 1 | 2310 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1138478 | |
| . | 570394 | |
| 1 | 2310 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1138478 | |
| . | 570394 | |
| 1 | 2310 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1138478 | |
| . | 570394 | |
| 1 | 2310 | 0.1% |
CANCELLATION_CODE
Categorical
MISSING
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 568084 |
| Missing (%) | 99.6% |
| Memory size | 4.4 MiB |
| B | |
|---|---|
| A | |
| C | 127 |
| D | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2310 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| B | 1392 | 0.2% |
| A | 789 | 0.1% |
| C | 127 | < 0.1% |
| D | 2 | < 0.1% |
| (Missing) | 568084 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 1392 | |
| a | 789 | |
| c | 127 | 5.5% |
| d | 2 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 1392 | |
| A | 789 | |
| C | 127 | 5.5% |
| D | 2 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2310 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 1392 | |
| A | 789 | |
| C | 127 | 5.5% |
| D | 2 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2310 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 1392 | |
| A | 789 | |
| C | 127 | 5.5% |
| D | 2 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2310 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 1392 | |
| A | 789 | |
| C | 127 | 5.5% |
| D | 2 | 0.1% |
DIVERTED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 MiB |
| 0.0 | |
|---|---|
| 1.0 | 1143 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1711182 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 569251 | |
| 1.0 | 1143 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 569251 | |
| 1.0 | 1143 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1139645 | |
| . | 570394 | |
| 1 | 1143 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1139645 | |
| . | 570394 | |
| 1 | 1143 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1139645 | |
| . | 570394 | |
| 1 | 1143 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1711182 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1139645 | |
| . | 570394 | |
| 1 | 1143 | 0.1% |
AIR_TIME
Real number (ℝ)
| Distinct | 635 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 3453 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.76931 |
| Minimum | 6 |
|---|---|
| Maximum | 672 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 65 |
| median | 101 |
| Q3 | 147 |
| 95-th percentile | 271 |
| Maximum | 672 |
| Range | 666 |
| Interquartile range (IQR) | 82 |
Descriptive statistics
| Standard deviation | 70.76748 |
|---|---|
| Coefficient of variation (CV) | 0.60604518 |
| Kurtosis | 2.6326529 |
| Mean | 116.76931 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.407162 |
| Sum | 66201311 |
| Variance | 5008.0362 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 61 | 4714 | 0.8% |
| 63 | 4621 | 0.8% |
| 66 | 4590 | 0.8% |
| 62 | 4528 | 0.8% |
| 64 | 4524 | 0.8% |
| 60 | 4485 | 0.8% |
| 65 | 4459 | 0.8% |
| 67 | 4444 | 0.8% |
| 56 | 4395 | 0.8% |
| 55 | 4390 | 0.8% |
| Other values (625) | 521791 |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 15 | < 0.1% |
| 10 | 17 | < 0.1% |
| 11 | 3 | < 0.1% |
| 12 | 4 | < 0.1% |
| 13 | 5 | < 0.1% |
| 14 | 11 | < 0.1% |
| 15 | 19 | < 0.1% |
| 16 | 66 |
| Value | Count | Frequency (%) |
| 672 | 1 | |
| 670 | 1 | |
| 668 | 1 | |
| 663 | 1 | |
| 661 | 1 | |
| 660 | 1 | |
| 657 | 1 | |
| 656 | 1 | |
| 655 | 1 | |
| 654 | 2 |
CARRIER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 784 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 481241 |
| Missing (%) | 84.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.501385 |
| Minimum | 0 |
|---|---|
| Maximum | 3786 |
| Zeros | 39145 |
| Zeros (%) | 6.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 21 |
| 95-th percentile | 96 |
| Maximum | 3786 |
| Range | 3786 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 73.723444 |
|---|---|
| Coefficient of variation (CV) | 3.1369829 |
| Kurtosis | 256.17866 |
| Mean | 23.501385 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 12.01631 |
| Sum | 2095219 |
| Variance | 5435.1463 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 39145 | 6.9% |
| 1 | 1736 | 0.3% |
| 6 | 1669 | 0.3% |
| 2 | 1640 | 0.3% |
| 3 | 1631 | 0.3% |
| 4 | 1622 | 0.3% |
| 15 | 1562 | 0.3% |
| 5 | 1528 | 0.3% |
| 7 | 1511 | 0.3% |
| 16 | 1432 | 0.3% |
| Other values (774) | 35677 | 6.3% |
| (Missing) | 481241 |
| Value | Count | Frequency (%) |
| 0 | 39145 | |
| 1 | 1736 | 0.3% |
| 2 | 1640 | 0.3% |
| 3 | 1631 | 0.3% |
| 4 | 1622 | 0.3% |
| 5 | 1528 | 0.3% |
| 6 | 1669 | 0.3% |
| 7 | 1511 | 0.3% |
| 8 | 1402 | 0.2% |
| 9 | 1375 | 0.2% |
| Value | Count | Frequency (%) |
| 3786 | 1 | |
| 2604 | 1 | |
| 2484 | 1 | |
| 2403 | 1 | |
| 2289 | 1 | |
| 2033 | 1 | |
| 2025 | 1 | |
| 1873 | 1 | |
| 1812 | 1 | |
| 1728 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 517 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 481241 |
| Missing (%) | 84.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9403834 |
| Minimum | 0 |
|---|---|
| Maximum | 1529 |
| Zeros | 85878 |
| Zeros (%) | 15.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1529 |
| Range | 1529 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 42.071916 |
|---|---|
| Coefficient of variation (CV) | 10.677112 |
| Kurtosis | 381.62417 |
| Mean | 3.9403834 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.789533 |
| Sum | 351297 |
| Variance | 1770.0461 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 85878 | 15.1% |
| 16 | 73 | < 0.1% |
| 3 | 72 | < 0.1% |
| 4 | 72 | < 0.1% |
| 2 | 66 | < 0.1% |
| 15 | 63 | < 0.1% |
| 9 | 63 | < 0.1% |
| 19 | 62 | < 0.1% |
| 7 | 58 | < 0.1% |
| 20 | 57 | < 0.1% |
| Other values (507) | 2689 | 0.5% |
| (Missing) | 481241 |
| Value | Count | Frequency (%) |
| 0 | 85878 | |
| 1 | 46 | < 0.1% |
| 2 | 66 | < 0.1% |
| 3 | 72 | < 0.1% |
| 4 | 72 | < 0.1% |
| 5 | 50 | < 0.1% |
| 6 | 52 | < 0.1% |
| 7 | 58 | < 0.1% |
| 8 | 49 | < 0.1% |
| 9 | 63 | < 0.1% |
| Value | Count | Frequency (%) |
| 1529 | 1 | |
| 1487 | 1 | |
| 1361 | 1 | |
| 1355 | 1 | |
| 1352 | 1 | |
| 1247 | 1 | |
| 1202 | 2 | |
| 1195 | 1 | |
| 1181 | 1 | |
| 1169 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 306 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 481241 |
| Missing (%) | 84.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.146546 |
| Minimum | 0 |
|---|---|
| Maximum | 1260 |
| Zeros | 44910 |
| Zeros (%) | 7.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 16 |
| 95-th percentile | 45 |
| Maximum | 1260 |
| Range | 1260 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 24.697448 |
|---|---|
| Coefficient of variation (CV) | 2.2157042 |
| Kurtosis | 305.1785 |
| Mean | 11.146546 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.812329 |
| Sum | 993748 |
| Variance | 609.96393 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 44910 | 7.9% |
| 1 | 2812 | 0.5% |
| 15 | 2116 | 0.4% |
| 16 | 1810 | 0.3% |
| 2 | 1727 | 0.3% |
| 3 | 1612 | 0.3% |
| 17 | 1608 | 0.3% |
| 18 | 1507 | 0.3% |
| 4 | 1504 | 0.3% |
| 5 | 1454 | 0.3% |
| Other values (296) | 28093 | 4.9% |
| (Missing) | 481241 |
| Value | Count | Frequency (%) |
| 0 | 44910 | |
| 1 | 2812 | 0.5% |
| 2 | 1727 | 0.3% |
| 3 | 1612 | 0.3% |
| 4 | 1504 | 0.3% |
| 5 | 1454 | 0.3% |
| 6 | 1372 | 0.2% |
| 7 | 1313 | 0.2% |
| 8 | 1209 | 0.2% |
| 9 | 1200 | 0.2% |
| Value | Count | Frequency (%) |
| 1260 | 1 | |
| 1148 | 1 | |
| 1134 | 1 | |
| 1026 | 1 | |
| 828 | 1 | |
| 800 | 1 | |
| 764 | 1 | |
| 704 | 1 | |
| 656 | 1 | |
| 629 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 98 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 481241 |
| Missing (%) | 84.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.21174834 |
| Minimum | 0 |
|---|---|
| Maximum | 276 |
| Zeros | 88394 |
| Zeros (%) | 15.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 276 |
| Range | 276 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.511695 |
|---|---|
| Coefficient of variation (CV) | 16.584286 |
| Kurtosis | 1692.179 |
| Mean | 0.21174834 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.049075 |
| Sum | 18878 |
| Variance | 12.332002 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 88394 | 15.5% |
| 8 | 36 | < 0.1% |
| 12 | 31 | < 0.1% |
| 17 | 29 | < 0.1% |
| 15 | 29 | < 0.1% |
| 16 | 27 | < 0.1% |
| 7 | 26 | < 0.1% |
| 6 | 25 | < 0.1% |
| 14 | 25 | < 0.1% |
| 20 | 23 | < 0.1% |
| Other values (88) | 508 | 0.1% |
| (Missing) | 481241 |
| Value | Count | Frequency (%) |
| 0 | 88394 | |
| 1 | 11 | < 0.1% |
| 2 | 15 | < 0.1% |
| 3 | 17 | < 0.1% |
| 4 | 13 | < 0.1% |
| 5 | 21 | < 0.1% |
| 6 | 25 | < 0.1% |
| 7 | 26 | < 0.1% |
| 8 | 36 | < 0.1% |
| 9 | 22 | < 0.1% |
| Value | Count | Frequency (%) |
| 276 | 1 | |
| 242 | 1 | |
| 227 | 1 | |
| 223 | 1 | |
| 187 | 1 | |
| 169 | 1 | |
| 162 | 1 | |
| 157 | 1 | |
| 156 | 1 | |
| 155 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 614 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 481241 |
| Missing (%) | 84.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.583514 |
| Minimum | 0 |
|---|---|
| Maximum | 2586 |
| Zeros | 45982 |
| Zeros (%) | 8.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 27 |
| 95-th percentile | 109 |
| Maximum | 2586 |
| Range | 2586 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 58.69079 |
|---|---|
| Coefficient of variation (CV) | 2.3874044 |
| Kurtosis | 136.08824 |
| Mean | 24.583514 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.2164906 |
| Sum | 2191694 |
| Variance | 3444.6088 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 45982 | 8.1% |
| 16 | 1149 | 0.2% |
| 15 | 1145 | 0.2% |
| 17 | 1101 | 0.2% |
| 18 | 1004 | 0.2% |
| 20 | 929 | 0.2% |
| 19 | 910 | 0.2% |
| 13 | 828 | 0.1% |
| 21 | 817 | 0.1% |
| 12 | 805 | 0.1% |
| Other values (604) | 34483 | 6.0% |
| (Missing) | 481241 |
| Value | Count | Frequency (%) |
| 0 | 45982 | |
| 1 | 545 | 0.1% |
| 2 | 616 | 0.1% |
| 3 | 602 | 0.1% |
| 4 | 608 | 0.1% |
| 5 | 633 | 0.1% |
| 6 | 676 | 0.1% |
| 7 | 664 | 0.1% |
| 8 | 707 | 0.1% |
| 9 | 715 | 0.1% |
| Value | Count | Frequency (%) |
| 2586 | 1 | |
| 1609 | 1 | |
| 1606 | 1 | |
| 1424 | 1 | |
| 1297 | 1 | |
| 1261 | 1 | |
| 1233 | 1 | |
| 1222 | 1 | |
| 1215 | 1 | |
| 1210 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 12/4/2023 12:00:00 AM | 9E | 4800 | 12953 | LGA | New York, NY | New York | 22 | 15016 | STL | St. Louis, MO | Missouri | 64 | 1846 | 1839.0 | -7.0 | 38.0 | 8.0 | 2046 | 2046.0 | 0.0 | 0.0 | NaN | 0.0 | 141.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 12/4/2023 12:00:00 AM | 9E | 4803 | 12953 | LGA | New York, NY | New York | 22 | 15096 | SYR | Syracuse, NY | New York | 22 | 2152 | 2144.0 | -8.0 | 14.0 | 19.0 | 2303 | 2301.0 | -2.0 | 0.0 | NaN | 0.0 | 44.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 12/4/2023 12:00:00 AM | 9E | 4804 | 15412 | TYS | Knoxville, TN | Tennessee | 54 | 12953 | LGA | New York, NY | New York | 22 | 647 | 642.0 | -5.0 | 12.0 | 7.0 | 857 | 822.0 | -35.0 | 0.0 | NaN | 0.0 | 81.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 12/4/2023 12:00:00 AM | 9E | 4805 | 12953 | LGA | New York, NY | New York | 22 | 15412 | TYS | Knoxville, TN | Tennessee | 54 | 1800 | 1754.0 | -6.0 | 13.0 | 4.0 | 2028 | 1951.0 | -37.0 | 0.0 | NaN | 0.0 | 100.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 12/4/2023 12:00:00 AM | 9E | 4808 | 12953 | LGA | New York, NY | New York | 22 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 1529 | 1523.0 | -6.0 | 18.0 | 3.0 | 1709 | 1639.0 | -30.0 | 0.0 | NaN | 0.0 | 55.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 12/4/2023 12:00:00 AM | 9E | 4808 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 12953 | LGA | New York, NY | New York | 22 | 1815 | 1810.0 | -5.0 | 11.0 | 7.0 | 1957 | 1926.0 | -31.0 | 0.0 | NaN | 0.0 | 58.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 12/4/2023 12:00:00 AM | 9E | 4810 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 15919 | XNA | Fayetteville, AR | Arkansas | 71 | 955 | 951.0 | -4.0 | 14.0 | 6.0 | 1053 | 1048.0 | -5.0 | 0.0 | NaN | 0.0 | 97.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 12/4/2023 12:00:00 AM | 9E | 4811 | 13198 | MCI | Kansas City, MO | Missouri | 64 | 12478 | JFK | New York, NY | New York | 22 | 704 | 700.0 | -4.0 | 23.0 | 8.0 | 1059 | 1056.0 | -3.0 | 0.0 | NaN | 0.0 | 145.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 12/4/2023 12:00:00 AM | 9E | 4812 | 12953 | LGA | New York, NY | New York | 22 | 13577 | MYR | Myrtle Beach, SC | South Carolina | 37 | 2040 | 2035.0 | -5.0 | 15.0 | 3.0 | 2254 | 2222.0 | -32.0 | 0.0 | NaN | 0.0 | 89.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 12/4/2023 12:00:00 AM | 9E | 4813 | 12478 | JFK | New York, NY | New York | 22 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 1340 | 1329.0 | -11.0 | 35.0 | 4.0 | 1510 | 1509.0 | -1.0 | 0.0 | NaN | 0.0 | 61.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 570384 | 7 | 12/31/2023 12:00:00 AM | YX | 5802 | 13342 | MKE | Milwaukee, WI | Wisconsin | 45 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1715 | 1705.0 | -10.0 | 28.0 | 6.0 | 2036 | 2034.0 | -2.0 | 0.0 | NaN | 0.0 | 115.0 | NaN | NaN | NaN | NaN | NaN |
| 570385 | 7 | 12/31/2023 12:00:00 AM | YX | 5807 | 11066 | CMH | Columbus, OH | Ohio | 44 | 12953 | LGA | New York, NY | New York | 22 | 800 | 753.0 | -7.0 | 15.0 | 10.0 | 956 | 935.0 | -21.0 | 0.0 | NaN | 0.0 | 77.0 | NaN | NaN | NaN | NaN | NaN |
| 570386 | 7 | 12/31/2023 12:00:00 AM | YX | 5810 | 11066 | CMH | Columbus, OH | Ohio | 44 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 950 | 941.0 | -9.0 | 10.0 | 7.0 | 1150 | 1127.0 | -23.0 | 0.0 | NaN | 0.0 | 89.0 | NaN | NaN | NaN | NaN | NaN |
| 570387 | 7 | 12/31/2023 12:00:00 AM | YX | 5813 | 14122 | PIT | Pittsburgh, PA | Pennsylvania | 23 | 11433 | DTW | Detroit, MI | Michigan | 43 | 620 | 614.0 | -6.0 | 16.0 | 7.0 | 749 | 715.0 | -34.0 | 0.0 | NaN | 0.0 | 38.0 | NaN | NaN | NaN | NaN | NaN |
| 570388 | 7 | 12/31/2023 12:00:00 AM | YX | 5816 | 12953 | LGA | New York, NY | New York | 22 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1200 | 1211.0 | 11.0 | 16.0 | 8.0 | 1325 | 1317.0 | -8.0 | 0.0 | NaN | 0.0 | 42.0 | NaN | NaN | NaN | NaN | NaN |
| 570389 | 7 | 12/31/2023 12:00:00 AM | YX | 5817 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 12953 | LGA | New York, NY | New York | 22 | 1200 | 1152.0 | -8.0 | 13.0 | 6.0 | 1328 | 1249.0 | -39.0 | 0.0 | NaN | 0.0 | 38.0 | NaN | NaN | NaN | NaN | NaN |
| 570390 | 7 | 12/31/2023 12:00:00 AM | YX | 5818 | 10693 | BNA | Nashville, TN | Tennessee | 54 | 12953 | LGA | New York, NY | New York | 22 | 740 | 733.0 | -7.0 | 32.0 | 8.0 | 1108 | 1104.0 | -4.0 | 0.0 | NaN | 0.0 | 111.0 | NaN | NaN | NaN | NaN | NaN |
| 570391 | 7 | 12/31/2023 12:00:00 AM | YX | 5837 | 12953 | LGA | New York, NY | New York | 22 | 10693 | BNA | Nashville, TN | Tennessee | 54 | 1420 | 1412.0 | -8.0 | 15.0 | 11.0 | 1603 | 1535.0 | -28.0 | 0.0 | NaN | 0.0 | 117.0 | NaN | NaN | NaN | NaN | NaN |
| 570392 | 7 | 12/31/2023 12:00:00 AM | YX | 5844 | 13485 | MSN | Madison, WI | Wisconsin | 45 | 12953 | LGA | New York, NY | New York | 22 | 1000 | 951.0 | -9.0 | 30.0 | 10.0 | 1324 | 1322.0 | -2.0 | 0.0 | NaN | 0.0 | 111.0 | NaN | NaN | NaN | NaN | NaN |
| 570393 | 7 | 12/31/2023 12:00:00 AM | YX | 5845 | 11057 | CLT | Charlotte, NC | North Carolina | 36 | 12953 | LGA | New York, NY | New York | 22 | 700 | 658.0 | -2.0 | 27.0 | 7.0 | 908 | 848.0 | -20.0 | 0.0 | NaN | 0.0 | 76.0 | NaN | NaN | NaN | NaN | NaN |